<%-- 
    Document   : entityDetails
    Created on : Dec 3, 2010, 7:15:22 PM
    Author     : navneet
--%>
<%@page import="com.myapp.global.user_listclass"%>
<%@taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%
    user_listclass ulc = new user_listclass();
%>
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <title>Web-Dev-Tool by Navneet Kumar</title>
        <meta http-equiv="Content-Language" content="English" />
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        <link rel="stylesheet" type="text/css" href="css/style.css" media="screen" />
        <link rel="stylesheet" type="text/css" href="css/style1.css" media="screen" />
        <script type="text/javascript" src="js/javascript4.js" ></script>
        <script type="text/javascript" src="js/javascript_front2.js" ></script>
        <script type="text/javascript">
            var page        = 1;
            var sortby      = 1;
            var sortas      = 1;
            var search      = 0;
            var searchfor   = 0;
            document.onloaded = getoverview();

            function getoverview(){
                var params = 'doOn=entityDetails&doThis=1';
                params += '&page='+page;
                params += '&sortby='+sortby;
                params += '&sortas='+sortas;
                params += '&search='+search;
                params += '&searchfor='+searchfor;
                getaddon("ajax/common.jsp?",params,"tabs","getoverview_cbk");
            }
            function getoverview_cbk()
            {
                //getObject("neetProcessingDivtabsData").style.display = 'none';
            }
            function getGroupCompanies(id)
            {
                getObject("neetProcessingDivGroupedComp1").style.display = '';
                getaddon("ajax/common.jsp?","doOn=entityDetails&doThis=2&GroupFilter="+id,"companyCombo_div","getGrpComp_cbk");
            }

            function getGrpComp_cbk()
            {
                getObject("neetProcessingDivGroupedComp1").style.display = 'none';
            }
            function getCompanySites(id)
            {
                getObject("neetProcessingDivGroupedComp2").style.display = '';
                getaddon("ajax/common.jsp?","doOn=entityDetails&doThis=3&CompanyFilter="+id,"sitesCombo_div","getCompSt_cbk");
            }

            function getCompSt_cbk()
            {
                getObject("neetProcessingDivGroupedComp2").style.display = 'none';
            }
            function getSiteEntity(id)
            {
                getObject("neetProcessingDivGroupedComp2").style.display = '';
                getaddon("ajax/common.jsp?","doOn=entityDetails&doThis=4&SiteFilter="+id,"EntityCombo_div","getStEntity_cbk");
            }

            function getStEntity_cbk()
            {
                getObject("neetProcessingDivGroupedComp2").style.display = 'none';
            }
        </script>
     </head>
    <body>
        <div id="wrap">
            <jsp:include page="/WEB-INF/jspf/header.jspf" flush="true" ></jsp:include>
            <div id="right">
                <%
                    if(session.getAttribute("currentUser") != null && session.getAttribute("currentUser").equals("admin"))
                    {
                %>
                <h1>Add Entity Field</h1>
                    <form method='post' action='addEntityField.do' >
                    <table style="width: 200px;">
                        <tbody>
                            <tr>
                                <td style="width:60px;">Group Name:</td>
                                <td style="width:140px;">
                                    <%= ulc.getAllGroups_Combo("groupId","","onchange='getGroupCompanies(this.value);'","") %>
                                </td>
                            </tr>
                            <tr>
                                <td>Company Name:</td>
                                <td>
                                    <div id="neetProcessingDivGroupedComp1" style='position:relative;display:none;'>
                                        <div style='position:absolute; top:0%; left:50%;'>
                                            <img alt=""  src='Image/icon_processing.gif' />
                                        </div>
                                    </div>
                                    <div id="companyCombo_div">
                                        <%= ulc.getAllCompanies_Combo("companyId","","onchange='getCompanySites(this.value);'","") %>
                                    </div>
                                </td>
                            </tr>
                            <tr>
                                <td>Site Name:</td>
                                <td>
                                    <div id="neetProcessingDivGroupedComp2" style='position:relative;display:none;'>
                                        <div style='position:absolute; top:0%; left:50%;'>
                                            <img alt=""  src='Image/icon_processing.gif' />
                                        </div>
                                    </div>
                                    <div id="sitesCombo_div">
                                        <%= ulc.getAllSites_Combo("siteId","","onchange='getSiteEntity(this.value);'","") %>
                                    </div>
                                </td>
                            </tr>
                            <tr>
                                <td>Entity Name:</td>
                                <td>
                                    <div id="neetProcessingDivGroupedComp2" style='position:relative;display:none;'>
                                        <div style='position:absolute; top:0%; left:50%;'>
                                            <img alt=""  src='Image/icon_processing.gif' />
                                        </div>
                                    </div>
                                    <div id="EntityCombo_div">
                                        <%= ulc.getAllEntities_Combo("entityId","","","") %>
                                    </div>
                                </td>
                            </tr>
                            <tr>
                                <td>Field</td>
                                <td>
                                    <input name='field_name' title='Field' type='text'/>
                                </td>
                            </tr>
                            <tr>
                                <td>Type</td>
                                <td>
                                    <select name='field_type' id='field_0_2'>
                                        <option value='INT'>INT</option>
                                        <option value='VARCHAR'>VARCHAR</option>
                                        <option value='TEXT'>TEXT</option>
                                        <option value='DATE'>DATE</option>
                                        <optgroup label='NUMERIC'>
                                            <option value='TINYINT'>TINYINT</option>
                                            <option value='SMALLINT'>SMALLINT</option>
                                            <option value='MEDIUMINT'>MEDIUMINT</option>
                                            <option value='INT'>INT</option>
                                            <option value='BIGINT'>BIGINT</option>
                                            <option value='-'>-</option>
                                            <option value='DECIMAL'>DECIMAL</option>
                                            <option value='FLOAT'>FLOAT</option>
                                            <option value='DOUBLE'>DOUBLE</option>
                                            <option value='REAL'>REAL</option>
                                            <option value='-'>-</option>
                                            <option value='BIT'>BIT</option>
                                            <option value='BOOL'>BOOL</option>
                                            <option value='SERIAL'>SERIAL</option>
                                        </optgroup>
                                        <optgroup label='DATE and TIME'>
                                            <option value='DATE'>DATE</option>
                                            <option value='DATETIME'>DATETIME</option>
                                            <option value='TIMESTAMP'>TIMESTAMP</option>
                                            <option value='TIME'>TIME</option>
                                            <option value='YEAR'>YEAR</option>
                                        </optgroup>
                                        <optgroup label='STRING'>
                                            <option value='CHAR'>CHAR</option>
                                            <option value='VARCHAR'>VARCHAR</option>
                                            <option value='-'>-</option>
                                            <option value='TINYTEXT'>TINYTEXT</option>
                                            <option value='TEXT'>TEXT</option>
                                            <option value='MEDIUMTEXT'>MEDIUMTEXT</option>
                                            <option value='LONGTEXT'>LONGTEXT</option>
                                            <option value='-'>-</option>
                                            <option value='BINARY'>BINARY</option>
                                            <option value='VARBINARY'>VARBINARY</option>
                                            <option value='-'>-</option>
                                            <option value='TINYBLOB'>TINYBLOB</option>
                                            <option value='MEDIUMBLOB'>MEDIUMBLOB</option>
                                            <option value='BLOB'>BLOB</option>
                                            <option value='LONGBLOB'>LONGBLOB</option>
                                            <option value='-'>-</option>
                                            <option value='ENUM'>ENUM</option>
                                            <option value='SET'>SET</option>
                                        </optgroup>
                                        <optgroup label='SPATIAL'>
                                            <option value='GEOMETRY'>GEOMETRY</option>
                                            <option value='POINT'>POINT</option>
                                            <option value='LINESTRING'>LINESTRING</option>
                                            <option value='POLYGON'>POLYGON</option>
                                            <option value='MULTIPOINT'>MULTIPOINT</option>
                                            <option value='MULTILINESTRING'>MULTILINESTRING</option>
                                            <option value='MULTIPOLYGON'>MULTIPOLYGON</option>
                                            <option value='GEOMETRYCOLLECTION'>GEOMETRYCOLLECTION</option>
                                        </optgroup>
                                    </select>
                                </td>
                            </tr>
                            <tr>
                                <td>Length/Values<sup class='footnotemarker' id='footnote_sup_1_1'>1</sup></td>
                                <td>
                                    <input name='field_length' type='text'/>
                                </td>
                            </tr>
                            <tr>
                                <td>Default<sup class='footnotemarker' id='footnote_sup_2_1'>2</sup></td>
                                <td>
                                    <select name='field_default_type'>
                                        <option value=''>None</option>
                                        <option value='USER_DEFINED'>As defined:</option>
                                        <option value='NULL'>NULL</option>
                                        <option value='CURRENT_TIMESTAMP'>CURRENT_TIMESTAMP</option>
                                    </select><br/>
                                    <input name='field_default_value' type='text'/>
                                </td>
                            </tr>
                            <tr>
                                <td>Collation</td>
                                <td>
                                    <select xml:lang='en' dir='ltr' name='field_collation'>
                                        <option value=''></option>
                                        <optgroup label='armscii8' title='ARMSCII-8 Armenian'>
                                            <option value='armscii8_bin' title='Armenian, Binary'>armscii8_bin</option>
                                            <option value='armscii8_general_ci' title='Armenian, case-insensitive'>armscii8_general_ci</option>
                                        </optgroup>
                                        <optgroup label='ascii' title='US ASCII'>
                                            <option value='ascii_bin' title='West European (multilingual), Binary'>ascii_bin</option>
                                            <option value='ascii_general_ci' title='West European (multilingual), case-insensitive'>ascii_general_ci</option>
                                        </optgroup>
                                        <optgroup label='big5' title='Big5 Traditional Chinese'>
                                            <option value='big5_bin' title='Traditional Chinese, Binary'>big5_bin</option>
                                            <option value='big5_chinese_ci' title='Traditional Chinese, case-insensitive'>big5_chinese_ci</option>
                                        </optgroup>
                                        <optgroup label='binary' title='Binary pseudo charset'>
                                            <option value='binary' title='Binary'>binary</option>
                                        </optgroup>
                                        <optgroup label='cp1250' title='Windows Central European'>
                                            <option value='cp1250_bin' title='Central European (multilingual), Binary'>cp1250_bin</option>
                                            <option value='cp1250_croatian_ci' title='Croatian, case-insensitive'>cp1250_croatian_ci</option>
                                            <option value='cp1250_czech_cs' title='Czech, case-sensitive'>cp1250_czech_cs</option>
                                            <option value='cp1250_general_ci' title='Central European (multilingual), case-insensitive'>cp1250_general_ci</option>
                                            <option value='cp1250_polish_ci' title='Polish, case-insensitive'>cp1250_polish_ci</option>
                                        </optgroup>
                                        <optgroup label='cp1251' title='Windows Cyrillic'>
                                            <option value='cp1251_bin' title='Cyrillic (multilingual), Binary'>cp1251_bin</option>
                                            <option value='cp1251_bulgarian_ci' title='Bulgarian, case-insensitive'>cp1251_bulgarian_ci</option>
                                            <option value='cp1251_general_ci' title='Cyrillic (multilingual), case-insensitive'>cp1251_general_ci</option>
                                            <option value='cp1251_general_cs' title='Cyrillic (multilingual), case-sensitive'>cp1251_general_cs</option>
                                            <option value='cp1251_ukrainian_ci' title='Ukrainian, case-insensitive'>cp1251_ukrainian_ci</option>
                                        </optgroup>
                                        <optgroup label='cp1256' title='Windows Arabic'>
                                            <option value='cp1256_bin' title='Arabic, Binary'>cp1256_bin</option>
                                            <option value='cp1256_general_ci' title='Arabic, case-insensitive'>cp1256_general_ci</option>
                                        </optgroup>
                                        <optgroup label='cp1257' title='Windows Baltic'>
                                            <option value='cp1257_bin' title='Baltic (multilingual), Binary'>cp1257_bin</option>
                                            <option value='cp1257_general_ci' title='Baltic (multilingual), case-insensitive'>cp1257_general_ci</option>
                                            <option value='cp1257_lithuanian_ci' title='Lithuanian, case-insensitive'>cp1257_lithuanian_ci</option>
                                        </optgroup>
                                        <optgroup label='cp850' title='DOS West European'>
                                            <option value='cp850_bin' title='West European (multilingual), Binary'>cp850_bin</option>
                                            <option value='cp850_general_ci' title='West European (multilingual), case-insensitive'>cp850_general_ci</option>
                                        </optgroup>
                                        <optgroup label='cp852' title='DOS Central European'>
                                            <option value='cp852_bin' title='Central European (multilingual), Binary'>cp852_bin</option>
                                            <option value='cp852_general_ci' title='Central European (multilingual), case-insensitive'>cp852_general_ci</option>
                                        </optgroup>
                                        <optgroup label='cp866' title='DOS Russian'>
                                            <option value='cp866_bin' title='Russian, Binary'>cp866_bin</option>
                                            <option value='cp866_general_ci' title='Russian, case-insensitive'>cp866_general_ci</option>
                                        </optgroup>
                                        <optgroup label='cp932' title='SJIS for Windows Japanese'>
                                            <option value='cp932_bin' title='Japanese, Binary'>cp932_bin</option>
                                            <option value='cp932_japanese_ci' title='Japanese, case-insensitive'>cp932_japanese_ci</option>
                                        </optgroup>
                                        <optgroup label='dec8' title='DEC West European'>
                                            <option value='dec8_bin' title='West European (multilingual), Binary'>dec8_bin</option>
                                            <option value='dec8_swedish_ci' title='Swedish, case-insensitive'>dec8_swedish_ci</option>
                                        </optgroup>
                                        <optgroup label='eucjpms' title='UJIS for Windows Japanese'>
                                            <option value='eucjpms_bin' title='Japanese, Binary'>eucjpms_bin</option>
                                            <option value='eucjpms_japanese_ci' title='Japanese, case-insensitive'>eucjpms_japanese_ci</option>
                                        </optgroup>
                                        <optgroup label='euckr' title='EUC-KR Korean'>
                                            <option value='euckr_bin' title='Korean, Binary'>euckr_bin</option>
                                            <option value='euckr_korean_ci' title='Korean, case-insensitive'>euckr_korean_ci</option>
                                        </optgroup>
                                        <optgroup label='gb2312' title='GB2312 Simplified Chinese'>
                                            <option value='gb2312_bin' title='Simplified Chinese, Binary'>gb2312_bin</option>
                                            <option value='gb2312_chinese_ci' title='Simplified Chinese, case-insensitive'>gb2312_chinese_ci</option>
                                        </optgroup>
                                        <optgroup label='gbk' title='GBK Simplified Chinese'>
                                            <option value='gbk_bin' title='Simplified Chinese, Binary'>gbk_bin</option>
                                            <option value='gbk_chinese_ci' title='Simplified Chinese, case-insensitive'>gbk_chinese_ci</option>
                                        </optgroup>
                                        <optgroup label='geostd8' title='GEOSTD8 Georgian'>
                                            <option value='geostd8_bin' title='Georgian, Binary'>geostd8_bin</option>
                                            <option value='geostd8_general_ci' title='Georgian, case-insensitive'>geostd8_general_ci</option>
                                        </optgroup>
                                        <optgroup label='greek' title='ISO 8859-7 Greek'>
                                            <option value='greek_bin' title='Greek, Binary'>greek_bin</option>
                                            <option value='greek_general_ci' title='Greek, case-insensitive'>greek_general_ci</option>
                                        </optgroup>
                                        <optgroup label='hebrew' title='ISO 8859-8 Hebrew'>
                                            <option value='hebrew_bin' title='Hebrew, Binary'>hebrew_bin</option>
                                            <option value='hebrew_general_ci' title='Hebrew, case-insensitive'>hebrew_general_ci</option>
                                        </optgroup>
                                        <optgroup label='hp8' title='HP West European'>
                                            <option value='hp8_bin' title='West European (multilingual), Binary'>hp8_bin</option>
                                            <option value='hp8_english_ci' title='English, case-insensitive'>hp8_english_ci</option>
                                        </optgroup>
                                        <optgroup label='keybcs2' title='DOS Kamenicky Czech-Slovak'>
                                            <option value='keybcs2_bin' title='Czech-Slovak, Binary'>keybcs2_bin</option>
                                            <option value='keybcs2_general_ci' title='Czech-Slovak, case-insensitive'>keybcs2_general_ci</option>
                                        </optgroup>
                                        <optgroup label='koi8r' title='KOI8-R Relcom Russian'>
                                            <option value='koi8r_bin' title='Russian, Binary'>koi8r_bin</option>
                                            <option value='koi8r_general_ci' title='Russian, case-insensitive'>koi8r_general_ci</option>
                                        </optgroup>
                                        <optgroup label='koi8u' title='KOI8-U Ukrainian'>
                                            <option value='koi8u_bin' title='Ukrainian, Binary'>koi8u_bin</option>
                                            <option value='koi8u_general_ci' title='Ukrainian, case-insensitive'>koi8u_general_ci</option>
                                        </optgroup>
                                        <optgroup label='latin1' title='cp1252 West European'>
                                            <option value='latin1_bin' title='West European (multilingual), Binary'>latin1_bin</option>
                                            <option value='latin1_danish_ci' title='Danish, case-insensitive'>latin1_danish_ci</option>
                                            <option value='latin1_general_ci' title='West European (multilingual), case-insensitive'>latin1_general_ci</option>
                                            <option value='latin1_general_cs' title='West European (multilingual), case-sensitive'>latin1_general_cs</option>
                                            <option value='latin1_german1_ci' title='German (dictionary), case-insensitive'>latin1_german1_ci</option>
                                            <option value='latin1_german2_ci' title='German (phone book), case-insensitive'>latin1_german2_ci</option>
                                            <option value='latin1_spanish_ci' title='Spanish, case-insensitive'>latin1_spanish_ci</option>
                                            <option value='latin1_swedish_ci' title='Swedish, case-insensitive'>latin1_swedish_ci</option>
                                        </optgroup>
                                        <optgroup label='latin2' title='ISO 8859-2 Central European'>
                                            <option value='latin2_bin' title='Central European (multilingual), Binary'>latin2_bin</option>
                                            <option value='latin2_croatian_ci' title='Croatian, case-insensitive'>latin2_croatian_ci</option>
                                            <option value='latin2_czech_cs' title='Czech, case-sensitive'>latin2_czech_cs</option>
                                            <option value='latin2_general_ci' title='Central European (multilingual), case-insensitive'>latin2_general_ci</option>
                                            <option value='latin2_hungarian_ci' title='Hungarian, case-insensitive'>latin2_hungarian_ci</option>
                                        </optgroup>
                                        <optgroup label='latin5' title='ISO 8859-9 Turkish'>
                                            <option value='latin5_bin' title='Turkish, Binary'>latin5_bin</option>
                                            <option value='latin5_turkish_ci' title='Turkish, case-insensitive'>latin5_turkish_ci</option>
                                        </optgroup>
                                        <optgroup label='latin7' title='ISO 8859-13 Baltic'>
                                            <option value='latin7_bin' title='Baltic (multilingual), Binary'>latin7_bin</option>
                                            <option value='latin7_estonian_cs' title='Estonian, case-sensitive'>latin7_estonian_cs</option>
                                            <option value='latin7_general_ci' title='Baltic (multilingual), case-insensitive'>latin7_general_ci</option>
                                            <option value='latin7_general_cs' title='Baltic (multilingual), case-sensitive'>latin7_general_cs</option>
                                        </optgroup>
                                        <optgroup label='macce' title='Mac Central European'>
                                            <option value='macce_bin' title='Central European (multilingual), Binary'>macce_bin</option>
                                            <option value='macce_general_ci' title='Central European (multilingual), case-insensitive'>macce_general_ci</option>
                                        </optgroup>
                                        <optgroup label='macroman' title='Mac West European'>
                                            <option value='macroman_bin' title='West European (multilingual), Binary'>macroman_bin</option>
                                            <option value='macroman_general_ci' title='West European (multilingual), case-insensitive'>macroman_general_ci</option>
                                        </optgroup>
                                        <optgroup label='sjis' title='Shift-JIS Japanese'>
                                            <option value='sjis_bin' title='Japanese, Binary'>sjis_bin</option>
                                            <option value='sjis_japanese_ci' title='Japanese, case-insensitive'>sjis_japanese_ci</option>
                                        </optgroup>
                                        <optgroup label='swe7' title='7bit Swedish'>
                                            <option value='swe7_bin' title='Swedish, Binary'>swe7_bin</option>
                                            <option value='swe7_swedish_ci' title='Swedish, case-insensitive'>swe7_swedish_ci</option>
                                        </optgroup>
                                        <optgroup label='tis620' title='TIS620 Thai'>
                                            <option value='tis620_bin' title='Thai, Binary'>tis620_bin</option>
                                            <option value='tis620_thai_ci' title='Thai, case-insensitive'>tis620_thai_ci</option>
                                        </optgroup>
                                        <optgroup label='ucs2' title='UCS-2 Unicode'>
                                            <option value='ucs2_bin' title='Unicode (multilingual), Binary'>ucs2_bin</option>
                                            <option value='ucs2_czech_ci' title='Czech, case-insensitive'>ucs2_czech_ci</option>
                                            <option value='ucs2_danish_ci' title='Danish, case-insensitive'>ucs2_danish_ci</option>
                                            <option value='ucs2_esperanto_ci' title='Esperanto, case-insensitive'>ucs2_esperanto_ci</option>
                                            <option value='ucs2_estonian_ci' title='Estonian, case-insensitive'>ucs2_estonian_ci</option>
                                            <option value='ucs2_general_ci' title='Unicode (multilingual), case-insensitive'>ucs2_general_ci</option>
                                            <option value='ucs2_hungarian_ci' title='Hungarian, case-insensitive'>ucs2_hungarian_ci</option>
                                            <option value='ucs2_icelandic_ci' title='Icelandic, case-insensitive'>ucs2_icelandic_ci</option>
                                            <option value='ucs2_latvian_ci' title='Latvian, case-insensitive'>ucs2_latvian_ci</option>
                                            <option value='ucs2_lithuanian_ci' title='Lithuanian, case-insensitive'>ucs2_lithuanian_ci</option>
                                            <option value='ucs2_persian_ci' title='Persian, case-insensitive'>ucs2_persian_ci</option>
                                            <option value='ucs2_polish_ci' title='Polish, case-insensitive'>ucs2_polish_ci</option>
                                            <option value='ucs2_roman_ci' title='West European, case-insensitive'>ucs2_roman_ci</option>
                                            <option value='ucs2_romanian_ci' title='Romanian, case-insensitive'>ucs2_romanian_ci</option>
                                            <option value='ucs2_slovak_ci' title='Slovak, case-insensitive'>ucs2_slovak_ci</option>
                                            <option value='ucs2_slovenian_ci' title='Slovenian, case-insensitive'>ucs2_slovenian_ci</option>
                                            <option value='ucs2_spanish2_ci' title='Traditional Spanish, case-insensitive'>ucs2_spanish2_ci</option>
                                            <option value='ucs2_spanish_ci' title='Spanish, case-insensitive'>ucs2_spanish_ci</option>
                                            <option value='ucs2_swedish_ci' title='Swedish, case-insensitive'>ucs2_swedish_ci</option>
                                            <option value='ucs2_turkish_ci' title='Turkish, case-insensitive'>ucs2_turkish_ci</option>
                                            <option value='ucs2_unicode_ci' title='Unicode (multilingual), case-insensitive'>ucs2_unicode_ci</option>
                                        </optgroup>
                                        <optgroup label='ujis' title='EUC-JP Japanese'>
                                            <option value='ujis_bin' title='Japanese, Binary'>ujis_bin</option>
                                            <option value='ujis_japanese_ci' title='Japanese, case-insensitive'>ujis_japanese_ci</option>
                                        </optgroup>
                                        <optgroup label='utf8' title='UTF-8 Unicode'>
                                            <option value='utf8_bin' title='Unicode (multilingual), Binary'>utf8_bin</option>
                                            <option value='utf8_czech_ci' title='Czech, case-insensitive'>utf8_czech_ci</option>
                                            <option value='utf8_danish_ci' title='Danish, case-insensitive'>utf8_danish_ci</option>
                                            <option value='utf8_esperanto_ci' title='Esperanto, case-insensitive'>utf8_esperanto_ci</option>
                                            <option value='utf8_estonian_ci' title='Estonian, case-insensitive'>utf8_estonian_ci</option>
                                            <option value='utf8_general_ci' title='Unicode (multilingual), case-insensitive'>utf8_general_ci</option>
                                            <option value='utf8_hungarian_ci' title='Hungarian, case-insensitive'>utf8_hungarian_ci</option>
                                            <option value='utf8_icelandic_ci' title='Icelandic, case-insensitive'>utf8_icelandic_ci</option>
                                            <option value='utf8_latvian_ci' title='Latvian, case-insensitive'>utf8_latvian_ci</option>
                                            <option value='utf8_lithuanian_ci' title='Lithuanian, case-insensitive'>utf8_lithuanian_ci</option>
                                            <option value='utf8_persian_ci' title='Persian, case-insensitive'>utf8_persian_ci</option>
                                            <option value='utf8_polish_ci' title='Polish, case-insensitive'>utf8_polish_ci</option>
                                            <option value='utf8_roman_ci' title='West European, case-insensitive'>utf8_roman_ci</option>
                                            <option value='utf8_romanian_ci' title='Romanian, case-insensitive'>utf8_romanian_ci</option>
                                            <option value='utf8_slovak_ci' title='Slovak, case-insensitive'>utf8_slovak_ci</option>
                                            <option value='utf8_slovenian_ci' title='Slovenian, case-insensitive'>utf8_slovenian_ci</option>
                                            <option value='utf8_spanish2_ci' title='Traditional Spanish, case-insensitive'>utf8_spanish2_ci</option>
                                            <option value='utf8_spanish_ci' title='Spanish, case-insensitive'>utf8_spanish_ci</option>
                                            <option value='utf8_swedish_ci' title='Swedish, case-insensitive'>utf8_swedish_ci</option>
                                            <option value='utf8_turkish_ci' title='Turkish, case-insensitive'>utf8_turkish_ci</option>
                                            <option value='utf8_unicode_ci' title='Unicode (multilingual), case-insensitive'>utf8_unicode_ci</option>
                                            </optgroup>
                                    </select>
                                </td>
                            </tr>
                            <tr>
                                <td>Null</td>
                                <td><input name='field_null' id='field_0_7' value='true' type='checkbox'/></td>
                            </tr>
                            <tr>
                                <td>Index</td>
                                <td>
                                    <select name='field_key'>
                                        <option value=''>---</option>
                                        <option value='PRIMARY KEY' title='PRIMARY KEY'>PRIMARY</option>
                                        <option value='UNIQUE' title='UNIQUE'>UNIQUE</option>
                                        <option value='INDEX' title='INDEX'>INDEX</option>
                                        <option value='FULLTEXT' title='FULLTEXT'>FULLTEXT</option>
                                    </select>
                                </td>
                            </tr>
                            <tr>
                                <td>Auto Increment</td>
                                <td><input name='field_auto' value='true' type='checkbox'/></td>
                            </tr>
                            <tr>
                                <td>Description</td>
                                <td>
                                    <input name='description' type='text'/>
                                </td>
                            </tr>
                            <tr>
                                <td colspan="2">
                                    <input name='do_save_data' value='Save' type='submit' />
                                </td>
                            </tr>
                        </tbody>
                        <tfoot>
                            <tr>
                                <td colspan="2" align="left">
                                    <span style='color:red'>
                                        <bean:write name="AFAFB" property="error" ignore="true" /><br/>
                                        <html:errors property="groupId" /><br/>
                                        <html:errors property="companyId" /><br/>
                                        <html:errors property="siteId" /><br/>
                                        <html:errors property="entityId" /><br/>
                                        <html:errors property="field_name" /><br/>
                                        <html:errors property="field_type" /><br/>
                                        <html:errors property="field_length" /><br/>
                                    </span>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </form>
                <div id="messageEntityDetails">
                    <% if(session.getAttribute("messageEntityDetailsDelete") != null){
                            out.println(session.getAttribute("messageEntityDetailsDelete"));
                        }
                    %>
                </div>
                <br/>
                <div id="tabs">
                    <div id="neetProcessingDivtabsData" style='position:relative;'>
                        <div style='position:absolute; top:0%; left:50%;'>
                            <img alt=""  src='Image/icon_processing.gif' />
                        </div>
                    </div>
                </div>
                <%
                    }
                    else
                    {
                %>
                    <jsp:include page="login.jsp" flush="true" ></jsp:include>
                <%
                    }
                %>
            </div>
            <div id="left">
                <%
                //if(session.getAttribute("currentUser") != null){
                %>
                    <jsp:include page="/WEB-INF/jspf/left_menu.jspf" flush="true" ></jsp:include>
                <%
                //}
                %>
            </div>
            <div style="clear: both;"> </div>
            <jsp:include page="/WEB-INF/jspf/footer.jspf" flush="true" ></jsp:include>
        </div>
    </body>
</html>